Create a database with unicode characers

Hi,

My database i have to store arabic as well as english. I read in the forum, it says we have to use nchar or nvarchar as data type for the column to store unicode data.

But i have to create only the database with unicode character set.Because the software am gng to install itself creates the table for the database.

Any solutions?

Regs,

Priya

[383 byte] By [PriyaRV] at [2007-12-25]

«« Change Source of Frame to display different web pages?
»» Is way to Override the Disabled appearance of ListView Control

# 1

unfortunately, there isn't a way. if the table is created with varchar, the column is defined as varchar.

oj at 2007-9-3 >

top of Msdn Tech,SQL Server,SQL Server Database Engine...

# 2

English and Arabic characters are included in the 1256 codepage and you don’t have to use “Unicode” if the target machines have Arabic support correctly. Make sure your regional settings are set to Arabic and that the language of non-Unicode programs are Arabic. For more details check Arabic support in Windows.

DinaLasheen-MSFT at 2007-9-3 >

SQL Server

SQL Server Database Engine

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech