VarChar and NVarChar Prob

> Hello

> I want to ask some question

> i have table field with "nvarchar" datatype and this

> field only contains English data , now i want to

> transfer this English Data to and table but there

> field type is varchar.so is it possible to transfer

> data from nvarchar to varchar in case on English Data

> only.

Maybe. Every database has a default character set, which is used for CHARs, VARCHARs, VARCHAR2s, CLOBs, etc; almost all character data types. Some but not all databases also support an additional "national" character set which is the character set used by NCHARs, NVARCHARs, NVARCHAR2s, or NCLOBs (if the DB has those data types).

You can move all the data stored in the national character set into the default character set if and only if the national character set is the same as, or a subset of, the default character set. For example, national data in a US7ASCII or ASCII character set can be moved into many default character sets, such as UTF8, LATIN1, EUC-CN, EUC-KR, MSWIN1252, HP8 and others.

Because data is converted into a standard intermediate character set within Java (UCS2), you can also move just the data that is totally within the intersection of the two character sets between two otherwise incompatible character sets. For exampl, LATIN1, LATIN2, LATIN3, and LATIN4 are all incompatible but each contains ASCII as a subset; any ASCII-only string can therefore be moved from one character set to the other.

Hope that helps.

StuDerbya at 2007-7-16 21:51:28 >