change Hindi language - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

change Hindi language

Author

Topic

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-05-05 : 03:04:09

I want to display few information say Student name, father name etc in Hindi language.but those information will store in English font.
what function i need to use to convert language....

pls suggest T-sql command

Regards,
avijit

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-05-05 : 06:29:43

Is it possible to change different language where the values are store in english language?

Regards,
avijit

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-05 : 07:22:27

you mean you pass english but you want to store hindi equivalent?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-05-05 : 23:32:15

say in student table colum1

name
__________
Avijit
Visakh

select name as EnglishFont, somefunction(name) as HindiFont from table
when i will run this query , it should display same name in Hindi (or some othe languge font) font.

Regards,
avijit

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-06 : 13:44:59

then you should have a separate column storing hindi equivalent

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-05-06 : 14:20:28

but user will enter english valu from front end application..
is it possible to submit english word in hindi equivalent font in separate colum???

Regards,
avijit

amitshar131
Starting Member

2 Posts

Posted - 2011-05-05 : 09:29:30

I want to use same table for hindi and english version of website. can i do it. or i need to store different tables to store english and hindi equivalents

example

itencode: 1
itemname: vegetable
subitemname: carrot

can i use same table to display 1, sabji ( in hindi), gajjar ( in hindi)

or i need to create a separate table and use
itemcode:1
itemname: sabji
subitemname: gajjar

and use this table while selecting hindi as language of my website

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2011-05-05 : 11:23:25

Please do not cross post.

All replies should go to this new thread:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=160285

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources