How to insert DBCS data in SQL Server from English Windows (170962)
The information in this article applies to:
This article was previously published under Q170962 SUMMARY
There are localized Microsoft Windows 95 and Windows NT 4.0 versions for simplified Chinese, traditional Chinese, Korean, and Japanese available in the East Asian market. We recommend that you use one of these East Asian localized Windows platforms to work with double-byte character set (DBCS) data. This article describes how to insert DBCS data into SQL Server 6.5 from an English version of Windows 95 or Windows NT 4.0.MORE INFORMATION
To have the DBCS data generated properly, an Input Method Editor (IME) is
needed. IME, also called a front-end processor, is an small program that
allows the user to enter the thousands of different characters used in Far
Eastern written languages using a standard 101-key keyboard. The localized
versions of Windows ship with standard IMEs that are based on the most
popular input methods used in each target country. Most applications that
target single-byte languages are IME-unaware. For this reason, the actual
DBCS data must be generated from a localized platform.
Suppose Notepad was used to create a data file in the localized Windows
platform. It is highly recommended to have the same tool used for the DBCS
string cut and paste purpose. This is to avoid the confusion of the code
page conversion between ANSI and OEM code pages.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
155233
SQL Server tools save files in OEM format
ODBC example: MSQUERY
Make sure the SQL Server ODBC Driver 2.5 or higher version is installed for
the DSN setup. From the SQL Server ODBC Setup dialog box, make sure both
the Use ANSI Quoted Identifiers (in the Login section) and Convert OEM To
ANSI Characters (in the Translation section) check boxes are clear (that
is, that they are not checked).
Copy the DBCS string from Notepad, paste it into the SQL Statement text box
in the Execute SQL dialog box, and put double quotation marks (") at the
beginning and end of the string. Edit the string with correct SQL Server
insertion statement, such as:
INSERT dbcstable VALUES "dbcs string"
Click Execute to insert it.
DB-Library example: ISQL/w
From ISQL/w, on the File menu, click Configure. This opens the Configure
ISQL/w dialog box. Click the Connection tab and make sure the ANSI To OEM
check box is clear (that is, not checked). Then make the connection to a
SQL Server.
Copy the DBCS string from Notepad, paste it into a Query window, then put
double quotation marks (") at the beginning and end of the string. Edit the
string with the correct SQL Server insertion syntax, such as:
INSERT dbcstable VALUES "dbcs string"
Click Execute to insert it.
| Modification Type: | Major | Last Reviewed: | 1/19/2006 |
|---|
| Keywords: | kbenv kbhowto kbinterop KB170962 kbAudDeveloper |
|---|
|