how to verify the database support Unicode 
Author Message
 how to verify the database support Unicode
Hi,

I've installed MS SQL Server 7 with

Character Set=1252(default)
Sort Order=Dictionary order, case-insensitive
Unicode Collation-Locale Identifier=Japanese (because I want people be
able to enter Japanese characters via my application)

My question is: how do I know it's using two bytes for each character,
ie., how do I confirm it is a unicode database? It does not seem to
say anything about Unicode during the setup.

Thanks!



Mon, 22 Mar 2004 07:44:27 GMT
 how to verify the database support Unicode

The datatype determines whether you use unicode or single byte. E.g.
nvarchar/nchar/ntext are unicode datatypes.
However for certain collations DBCS will be used for non-unicode datatypes
which takes either 1 or 2 bytes
depending on character.

So you should be able to use Japanese characters (either DBCS or Unicode
depending on datatype).

In 8.0 you can choose different collations on column level.


Quote:
> Hi,

> I've installed MS SQL Server 7 with

> Character Set=1252(default)
> Sort Order=Dictionary order, case-insensitive
> Unicode Collation-Locale Identifier=Japanese (because I want people be
> able to enter Japanese characters via my application)

> My question is: how do I know it's using two bytes for each character,
> ie., how do I confirm it is a unicode database? It does not seem to
> say anything about Unicode during the setup.

> Thanks!



Mon, 22 Mar 2004 08:02:51 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Need to upgrade a non-unicode database to unicode database

2. Unicode support for database classes

3. Help needed, Unicode and database to support multiple language

4. Relational Database which supports Unicode

5. Relational Databases supporting UNICODE

6. Conversion Unicode database to a non-Unicode

7. how to get unicode string from database in an none-unicode project

8. Database - Verify Database

9. Full (UCS-2) Unicode Support

10. UNICODE support?

11. Does SQL Server support Unicode?

12. Unicode Support


 
Powered by phpBB® Forum Software