| SitePoint Sponsor |
|
|
User Tag List
Results 1 to 4 of 4
Thread: Text Formatting from SQL Server
-
Jul 13, 2004, 04:09 #1SitePoint Wizard
- Join Date
- Mar 2000
- Location
- Muskegon, MI
- Posts
- 2,328
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Text Formatting from SQL Server
I have a table with records that were imported from an Excel spreadsheet. Within this table are several text fields that include special formatting like TM for trademark or the R with a circle for registered. The formating is there in the spreadsheet and in SQL when I look at it through Enterprise Manager, however, it is not there when displayed on a web page. I just end up with a 'T'.
-
Jul 13, 2004, 05:33 #2Original Gangster
- Join Date
- Oct 2000
- Location
- Philadelphia, PA
- Posts
- 4,708
- Mentioned
- 2 Post(s)
- Tagged
- 0 Thread(s)
What is the data type in the table?
"Does this napkin smell like chloroform?"
...now with SnapFoo!
My Blog | My Twitter | My Company | SitePoint Podcast
*** Matt Mullenweg on the SitePoint Podcast ***
-
Jul 13, 2004, 10:11 #3SitePoint Wizard
- Join Date
- Mar 2000
- Location
- Muskegon, MI
- Posts
- 2,328
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
nvarchar(255)
-
Jul 14, 2004, 06:42 #4SitePoint Wizard
- Join Date
- Mar 2000
- Location
- Muskegon, MI
- Posts
- 2,328
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Someone posted this SQL Server function on another forum, but I am not sure what to actually put in for text - it just looks like TM in upper half.
Code:REPLACE(MyColumn, 'YourTradeMarkCharacterHere', '&tm;')
Bookmarks