Foreign Language Support.

Question

Foreign Language Support.

nilesh k

Default port

Points: 1457
More actions
August 24, 2009 at 4:41 am

#138321

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.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Andeavour SSCrazy Points: 2600 More actions · Answer 1

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.

nilesh k Default port Points: 1457 More actions · Answer 2

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.

Andeavour SSCrazy Points: 2600 More actions · Answer 3

:w00t: 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 😉

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.

nilesh k Default port Points: 1457 More actions · Answer 4

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.

kramaswamy SSCoach Points: 18181 More actions · Answer 5

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.

nilesh k Default port Points: 1457 More actions · Answer 6

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,