Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 9th, 2007, 10:32 AM
duclt2002 duclt2002 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2006
Posts: 4 duclt2002 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 24 m 20 sec
Reputation Power: 0
Unicode - help me

I have a form with 2 textbox, name txtMa_bp and txtTen_bp
when click submit:


FbConnection lCn = new FbConnection(Thuvien.Kncode());
FbCommand cmdLenh = new FbCommand();
cmdLenh.Connection = lCn;
string lSql;
lSql = "Insert into Dmbp(ma_bp, ten_bp) " +
"values ('" + pMa_bp + "', '" + pTen_bp + "')";
//I can see lSql - unicode font
cmdLenh.CommandText = lSql;
cmdLenh.CommandType = CommandType.Text;
lCn.Open();
cmdLenh.ExecuteNonQuery();
lCn.Close();

when insert into database, it loss unicode font
why ?????

Reply With Quote
  #2  
Old January 9th, 2007, 10:37 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,826 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 1 Day 10 h 40 m 58 sec
Reputation Power: 278
Server, client and connection charset settings are?

Reply With Quote
  #3  
Old January 9th, 2007, 06:18 PM
duclt2002 duclt2002 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2006
Posts: 4 duclt2002 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 24 m 20 sec
Reputation Power: 0
sorry, i dont know

I dont know what you say
can you explain it to me

Reply With Quote
  #4  
Old January 11th, 2007, 02:48 AM
fikret fikret is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Location: Sarajevo, Bosnia
Posts: 111 fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 5 h 17 m 43 sec
Reputation Power: 8
Quote:
Originally Posted by duclt2002
I dont know what you say
can you explain it to me


What charset you used when you have created that database? And what charset you used as param when you are connecting to that database?
Comments on this post
pabloj agrees: Thanks

Reply With Quote
  #5  
Old January 11th, 2007, 08:04 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,826 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 1 Day 10 h 40 m 58 sec
Reputation Power: 278
Check the PDF document inside this zip file from the Fourth International Firebird Conference it contains all the details

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > Unicode - help me


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway