Globalization

[icanmakeiteasy]

Hi, in my database table having different type of languages like

id uname
1 Évian-les-Bains
2 Évreux
3 Eysines
4 Île d?Aix
5 L?Isle-d?Abeau

can i get uname values in to english language using select query thanks in advance

icanmakeiteasy

[Rupesh Kumar Swami]

whether you try following query? select id, uname as [english language] from tableName

Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

[ChandraRam]

icanmakeiteasy wrote:

can i get uname values in to english language using select query

Do you mean translate to English? If so, then I don't think that is possible.