How to save Gujarati font in Sql Server
-
In My Application I us Vb.net 2008 in C# and my database is Sql server 2005 express Edition In My application I am usig gujarati font so how can i save that gujarati font in database Plese help me on this matter if any other idea so please tell me also please help..........
-
In My Application I us Vb.net 2008 in C# and my database is Sql server 2005 express Edition In My application I am usig gujarati font so how can i save that gujarati font in database Plese help me on this matter if any other idea so please tell me also please help..........
Hi, you cannot store strings with a specific font in a sql server. A font is just a description how to display characters. What you want to achieve is that the sql server stores a specific encoding. So set the encoding of your sql database to the one used for your language (try to google this, I don't know which encoding supports your language). This should help. Regards Sebastian
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
-
In My Application I us Vb.net 2008 in C# and my database is Sql server 2005 express Edition In My application I am usig gujarati font so how can i save that gujarati font in database Plese help me on this matter if any other idea so please tell me also please help..........
Aajignesh, read the following carefully I think this will help you: For example table name is Customer. Customer table have two coulmns (CustomerId & CustomerName). You want to store Gujarati Font in second column (CustomerName). Set the datatype of CustomerName column to nvarchar(50), Then make the query look like as below: Insert into Customer (CustomerId, CustomerName) values ('1', N'Write Name in Gujarati Font') Note: Don't Forget to install Gujarati Font on your operating system. Incase of any confusion feel free to ask muhammadshahidfarooq@yahoo.com
-
Aajignesh, read the following carefully I think this will help you: For example table name is Customer. Customer table have two coulmns (CustomerId & CustomerName). You want to store Gujarati Font in second column (CustomerName). Set the datatype of CustomerName column to nvarchar(50), Then make the query look like as below: Insert into Customer (CustomerId, CustomerName) values ('1', N'Write Name in Gujarati Font') Note: Don't Forget to install Gujarati Font on your operating system. Incase of any confusion feel free to ask muhammadshahidfarooq@yahoo.com
Thanks sir That's Work 1) sir what is the mening of N in this if u know so please tell me thanks again to help me on this problem Sir One another problem please help me on it 1) how can i set by default font set gujarati i try but every time i select language than write in gujarati other wise by default i write in english so if u have any idea so plese tell me thanks you..........
-
Thanks sir That's Work 1) sir what is the mening of N in this if u know so please tell me thanks again to help me on this problem Sir One another problem please help me on it 1) how can i set by default font set gujarati i try but every time i select language than write in gujarati other wise by default i write in english so if u have any idea so plese tell me thanks you..........
N in insert query represent Unicode. Q:Why we use Unicode? A: Unicode can represent over 65,000 characters, it accommodates many languages whose characters are not represented in ANSI encoding. ANSI character encoding represents characters in one byte, it is limited to 256 characters. For default input language, follow these steps: 1. Click Start, click Run, type intl.cpl, and then click OK. 2. Click the Languages tab, and then click Details. 3. On the Settings tab, click Add. 4. Select the language that you want in the Input language list, and then click OK. 5. Select the language that you want in the Default input language list. 6. Click OK two times.
-
N in insert query represent Unicode. Q:Why we use Unicode? A: Unicode can represent over 65,000 characters, it accommodates many languages whose characters are not represented in ANSI encoding. ANSI character encoding represents characters in one byte, it is limited to 256 characters. For default input language, follow these steps: 1. Click Start, click Run, type intl.cpl, and then click OK. 2. Click the Languages tab, and then click Details. 3. On the Settings tab, click Add. 4. Select the language that you want in the Input language list, and then click OK. 5. Select the language that you want in the Default input language list. 6. Click OK two times.
Thanks you.