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 |
|
loveojha
Starting Member
3 Posts |
 Posted - 2008-03-07 : 00:31:25
|
| Hi Forumers,This is my first post in this forum. :)My question is regarding how to know the character set of the sql server DB.When I query the DB using sp_helpsort, I get the "Latin1-General" as the server default collation. I just want to know the correct character mapping code like (UTF,ASCII, ISO8859, etc.)Thanks in advance. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-07 : 00:32:57
|
Look under microsoft or books online for COLLATION and Service Broker for SQL Server.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
loveojha
Starting Member
3 Posts |
Posted - 2008-03-07 : 00:39:08
|
quote:
Originally posted by dataguru1971
Look under microsoft or books online for COLLATION and Service Broker for SQL Server.
Poor planning on your part does not constitute an emergency on my part.
Hi dataguru, thanks for the quick reply. Can you please let me know the location which you are talking about.Thanks |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-07 : 00:48:59
|
http://msdn2.microsoft.com/en-us/library/aa174903(SQL.80).aspxhttp://msdn2.microsoft.com/en-us/library/aa214408(SQL.80).aspxthat should get you going.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
loveojha
Starting Member
3 Posts |
Posted - 2008-03-07 : 01:16:01
|
| Thanks a bunch dataguru.This got me to the SELECT *FROM ::fn_helpcollations() query through which I could see the name of the collation and the description.Actually data that I am going after is in Japanese_Unicode_CI_AS_KS_WS. And I want to load this data to Oracle database. But Oracle does not understand "Japanese_Unicode_CI_AS_KS_WS", the character set that Oracle can understand are http://www.itk.ilstu.edu/docs/Oracle/server.101/b10749/applocaledata.htm#g680371So I just wanted to know what is the equivalent codename for the sql collation, which I can use for this data transfer.Thanks |
|
|
|
|
|
|
The Character Map Set Question