Re: [Firebird-net-provider] Character Set Confusion For Spanish Characters

[Alexander Muylaert]

Hi

 

 

UTF8

 

Both your database and your connectionstrings  (Everywhere…)

 

Van: Steve Harp [mailto:st...@abelscreening.com] 
Verzonden: dinsdag 13 november 2012 21:20
Aan: firebird-net-provider@lists.sourceforge.net
Onderwerp: [Firebird-net-provider] Character Set Confusion For Spanish
Characters

 

I’m sure this has been discussed a thousand times but I’m clueless.  

 

I have a database that contains Spanish text in both VarChar and BLOB
(sub_type 1) fields.  I’m using C# and the .NET connector v2.6.5.0 in a .NET
v4.0 application.  I can insert data into the database using UTF8 and view
it in FlameRobin to verify it’s correctness.   However, if I try to read it
back using UTF8, I get character substitutions that are incorrect for some
of the Spanish characters (like the á).  I have to read it back using
character set NONE to get back correct results.  The database has no default
character set defined.

 

What character set should I be using for English and Spanish text and why
doesn’t the same character set used to write the data read it back
correctly?

 

Thanks…

 


------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider