I am chinese guy, and my OS(WinNT4) is a Simple Chinese version, so the default zone is Chinese(RPC). Now, I wanna to insert a record into database(MS SQL7.0), the value is a chinese word delivered by a variable. but ODBC always return error, and most situation the error message is 'error syntax' near xxxx(chinese word). how can I do it. whether I need to change the character set before execute my SQL.
subject: database operation with other character set