ascii to ansii

[x3d]

how can i retrive from database preserving its ansii format ?
let say, im doing my database in access, then how can i retrieve that in its ansii form, because when i retrive it it changes .... because im dealing with jap. and chinese character so i need to preseve the ansii, but what happens is when i retrieve a certain data it would appear "?" in question marks....
thanx

[RobIII]

First of all, it's actually not ANSI, but UNICODE or DBCS. Second, VB is completely UNICODE & DBCS compliant, as is Access.

But i think what you need is a chinese font to display the data.

You might want to check MSDN's chapter for this (so check all following chapters for more info by expanding the treeview).

-------------

From MSDN
ANSI
ANSI is the most popular character standard used by personal computers. Because the ANSI standard uses only a single byte to represent each character, it is limited to a maximum of 256 character and punctuation codes. Although this is adequate for English, it doesn't fully support many other languages.

DBCS
DBCS is used in Microsoft Windows systems that are distributed in most parts of Asia. It provides support for many different East Asian language alphabets, such as Chinese, Japanese, and Korean. DBCS uses the numbers 0 – 128 to represent the ASCII character set. Some numbers greater than 128 function as lead-byte characters, which are not really characters but simply indicators that the next value is a character from a non-Latin character set. In DBCS, ASCII characters are only 1 byte in length, whereas Japanese, Korean, and other East Asian characters are 2 bytes in length.

Unicode
Unicode is a character-encoding scheme that uses 2 bytes for every character. The International Standards Organization (ISO) defines a number in the range of 0 to 65,535 (216 – 1) for just about every character and symbol in every language (plus some empty spaces for future growth). On all 32-bit versions of Windows, Unicode is used by the Component Object Model (COM), the basis for OLE and ActiveX technologies. Unicode is fully supported by Windows NT. Although both Unicode and DBCS have double-byte characters, the encoding schemes are completely different.

[x3d]

thank you for correcting me...
unicode it is ...
i have the chinese fonts installed...

what command can i use to display that ?
i use the data environment
ex.
text1= abc.recordset("name")

Please format your code...

[RobIII]

Have you even read the MSDN pages? I think not...
All info you need is up there...

[x3d]

thnx