Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
melcraig
Starting Member
39 Posts |
 Posted - 2006-04-18 : 18:28:54
|
| I have a program to install that says the SQL DB has to be UTF-8. How do I know if my SQL Server Instance is UTF-8?Thanks, Mel |
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
melcraig
Starting Member
39 Posts |
Posted - 2006-04-18 : 19:38:08
|
I guess I'm still missing something.I'm just not understanding  Thanks, Mel |
 |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2006-04-18 : 19:56:21
|
| SQL Server 2K stores Unicode as UCS-2, not UTF-8. The link I posted offers you some possible solutions for storing UTF-8 data in SQL Server database, but it is basically saying that it offers no native support.Nathan Skerl |
|
|
|
melcraig
Starting Member
39 Posts |
Posted - 2006-04-18 : 20:02:29
|
| So the work around is not a DB setting it is in the pages/connections?Thanks, Mel |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2006-04-18 : 20:20:06
|
| Right, when data is sent to the db, it would be converted to UCS-2 and stored in the db... then on export to the client IIS would convert it to UTF-8, as an example of the ASP workaround.Nathan Skerl |
|
|
|
melcraig
Starting Member
39 Posts |
Posted - 2006-04-19 : 10:23:08
|
| Thanks for all your help.Mel |
|
|
|
|
|
|
UTF-8