SEO

#1 (**permalink**) 02-27-2008, 09:11 PM

My application uses ODBC3 to connect to sql server.And in one table a
field is of type nvarchar. When I fetch the data, there is problem with
Arabic and Korean words but not with Chinese or Japanese. I have
searched for the information but with no useful help.Did someone
encounter the problem and know the reason?

#2 (**permalink**) 02-27-2008, 09:11 PM

Make sure:

1. You have the latest service pack on SQL Server.
2. Your MDAC is the latest version on both the server AND the application
server. If you go to
http://msdn.microsoft.com/data/ref/m...s/default.aspx, you can
download the component checker to see what version you are at.

--
MeanOldDBA
derrickleggett@hotmail.com
http://weblogs.sqlteam.com/derrickl

When life gives you a lemon, fire the DBA.

"jackyshi3333@yahoo.com.cn" wrote:

> My application uses ODBC3 to connect to sql server.And in one table a
> field is of type nvarchar. When I fetch the data, there is problem with
> Arabic and Korean words but not with Chinese or Japanese. I have
> searched for the information but with no useful help.Did someone
> encounter the problem and know the reason?
>
>

#3 (**permalink**) 02-27-2008, 09:11 PM

Thanks.
I have fixed the problem.
When I called SQLBindCol or SQLGetData, the TargetType parameter
passed as SQL_UNICODE_CHAR,the result will be okey.
I don't know whether this is proper, it seems that this is a temporary
solution.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

nvarchar field error