Tuesday, February 14, 2012

create UTF-8 database using enterprise manager sqlserver2000

Friends
I know how to create a database using enterprise manager in sql server 7 or 2000.
But i want to create a database where i have to set the unicode as UTF8 for the whole database.
is it possible?
if yes, how can i do that.
thanks
sathyguySo you only want it to allow 8 bit OEM values in your database ?!?! No, that is not possible in SQL 2000.

-PatP|||thanks for your reply.
my problem is the new database which im going to create is having some 10 tables. In those 10 tables i have to insert all sorts of languages. ie., chinese, arabic, english etc.....
instead of setting the datatype of each coloumn in each table.
is there any posssibility to set it for the whole database. i mean the character set for the whole database.

thanks
sathyguy|||I think what you really want is SQL N types (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3ss4.asp) (including NTEXT (http://msdn.microsoft.com/library/en-us/tsqlref/ts_nos-nz_0lyd.asp)) that allow you to store Unicode data.

-PatP

No comments:

Post a Comment