Re: how to store and retrieve hindi characters into the database

  • From: "The Elf" <inthaneelf@xxxxxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Sun, 24 Oct 2010 18:17:28 -0700

hey great! and thanks for the info, I'm sure it will assist someone out here in the future!


I'm filing it for future reference myself.
the elf
Moderator, Blind Access Help
Owner: Alacorn Computer Enterprises
Specialists in customized computers and peripherals
- own the might and majesty of a Alacorn!
www.alacorncomputer.com
proprietor, The Grab Bag,
for blind computer users and programmers
http://grabbag.alacorncomputer.com

----- Original Message ----- From: "prateek aggarwal" <prateekagarwal99@xxxxxxxxx>
To: "programmingblind" <programmingblind@xxxxxxxxxxxxx>
Sent: Saturday, October 23, 2010 12:47 AM
Subject: Re: how to store and retrieve hindi characters into the database


hi folks,
just wanted to inform that by doing my hands a little dirty with
storing and retrieving
hindi, I’ve done it successfully this noon.

Those who would like to know how did I do it,
I had to install the hindi scripts first, and then configure it as
input language in Unicode mode.
After ime configuration, I’ve configured the database successfully.
One major change that I had to do was in dataType, where I used nchar
and nvarchar in place of char and varchar.

There were a bit of other play-arounds, but finally I got it done.

I also found out that access 2007 supports the Unicode as well, so if
you ever need to store the local language values of your nation I.E.
urdu, Korean, Japanese, Chinese etc, you should be able to do it
without any huge  problem.

Thanks all for your good wishes.

Cheers!
Prateek agarwal.





On 10/22/10, prateek aggarwal <prateekagarwal99@xxxxxxxxx> wrote:
Hi mates,
A project that I’ve got today requires me to store and retrieve hindi
characters into the database.
It’s a windows based software, hence I’m going to use c# as front end
and sql server as database.

Since I haven’t worked on this kind of application previously, I’ve
been trying to figure out how can it be done.

Those who don’t know, hindi is the national language of India which is
widely spoken across the nation.

Basically, I think I need to store and retrieve Unicode based values,
so does someone have any idea about how can I do it?

I know that defaultly it stores the values in ansi format, hence
something need to be done for storing and retrieving values in
Unicode.

Just now, I was told that the controls
available with "Microsoft Forms 2.0 Object Library" are capable of
showing the unicode texts.

It’s a bit confusing to me, since I have had no experience of this
kind of something in past.

If any of you have some idea about how is it done, please share with
me asap, will be of real help.

I will look forward for your early responses.

Cheers!
Prateek agarwal.

__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind

__________
View the list's information and change your settings at //www.freelists.org/list/programmingblind

Other related posts: