Hindi text in nText column SQL Server 2005

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 2005 Forums

Transact-SQL (2005)

Hindi text in nText column SQL Server 2005

Author

Topic

pawangargmit
Starting Member

2 Posts

Posted - 2010-02-04 : 11:48:17

We are using SQL Server 2005, and saving Hindi, English, Japaneese, Chiness languages in nText column.
This all we are doing using google analytical. However, we don't know how to know which value is Hindi or Englsh as they are encoded.

Please suggest how to write a query to know the count for all the rows having Hindi text.

Pawan Garg

Sachin.Nand

2937 Posts

Posted - 2010-02-04 : 12:16:40

Maybe u will hv to change the DB design a bit & put another column against the nText column which saves the language id.
ex


Language(nText) , Languageid
Chinese text1         1
Japanese text1        2
Chinese text2         1
Hindi   text1         3

etc

PBUH

pawangargmit
Starting Member

2 Posts

Posted - 2010-02-04 : 13:41:06

This will not solve the problem, reason is we have a textarea in which user can put above listed languages text without knowing us which language is this...
So again I am putting my question,
Please suggest how to write a query to know the count for all the rows having Hindi text?

Pawan Garg

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources