Foreign Language Support.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Foreign Language Support.

Foreign Language Support.

Rate Topic

Display Mode

Topic Options

Author

Message

nilesh k

Posted Monday, August 24, 2009 4:41 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 12, 2012 9:52 AM
Points: 36, Visits: 90

Hi,

I have nvarchar field which contains data in different languages.

Whenever i fire a select query on this table i get improper data.

(??? characters instead of actual data)

If any one can help me with this.

Thanks,

Nilesh K.

Post Attachments

Error.JPG (7 views, 99.92 KB)

Post #775877

Andeavour

Posted Monday, August 24, 2009 4:54 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 5:34 AM
Points: 981, Visits: 821

I once developed a system to work in Arabic, and saw a similar situation if I didn't have the language and font sets on my development machine. Try adding the appropriate languages to your Windows locale setings.

Post #775887

nilesh k

Posted Monday, August 24, 2009 5:38 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 12, 2012 9:52 AM
Points: 36, Visits: 90

Hello,

Thanks for your reply.
In this case i am able to see results for other data with same languageID.
Please refer to attached file.

Post Attachments

Error.JPG (15 views, 210.92 KB)

Post #775908

Andeavour

Posted Monday, August 24, 2009 5:39 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 5:34 AM
Points: 981, Visits: 821

Also (just remembered) you'll have to make sure your development machine is set to display Non-Unicode characters in the appropriate language.

It's been a while since I developed the Arabic system, but it's slowly coming back to me Wink

Not sure what would stop it showing certain character results but not others though... Check your non-unicode settings, but it may be a different issue. I had mixed English, French and Arabic in tables and could see the English and French, but needed to set non-unicode to Arabic to stop it just showing "?????????" for the Arabic. Unfortunately this does have knock on effects for other areas of Windows.

Good luck.

Post #775909

nilesh k

Posted Monday, August 24, 2009 7:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 12, 2012 9:52 AM
Points: 36, Visits: 90

Actually,

It does support newly Inserted Foreign language characters but fails for Updating records with Foreign language characters.
I am finding it very strange.
I have already tried installing Languages Using 'Regional and Language' options from 'Control Panel'

Regards,
Nilesh.

Post #775969

kramaswamy

Posted Monday, August 24, 2009 12:45 PM

Right there with Babe

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:53 PM
Points: 785, Visits: 1,534

You're sure that when you inserted that information into the field, you inserted NVARCHAR characters? if you were using a stored proc, the stored proc needs to accept NVARCHAR, not VARCHAR, and if you're passing parameters to an EXEC statement, then you need to append the N' before each field that's NVARCHAR.

Post #776241

nilesh k

Posted Monday, August 24, 2009 10:28 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 12, 2012 9:52 AM
Points: 36, Visits: 90

Hello,

i got the solution.

I should append 'N' to the value which contains Foreign language or special characters.
As to recognize it as foreign language.

Eg. Insert into TableName Values(N'Комплеующи')

Regards,

Post #776433

« Prev Topic | Next Topic »

Permissions