Re: [Firebird-net-provider] Charset problems

2009-03-14 Thread Barbiturico76
Jiri Cincura ha scritto: On Thu, Mar 12, 2009 at 17:20, Barbiturico76 lucadomenos...@nospuminwind.it wrote: But if there's no other way. You cna do it in place, of course. But you will face problems with dependencies etc. And if it's not 10GB database, this will be

Re: [Firebird-net-provider] Charset problems

2009-03-14 Thread Jiri Cincura
On Sat, Mar 14, 2009 at 09:48, Barbiturico76 lucadomenos...@nospuminwind.it wrote: Yes, but still one question My tables are ASCII encoded and chars are misread during acquisition in the NET environment. How can FlameRobin read the text correctly? FR is probably using as a guess local

Re: [Firebird-net-provider] Charset problems

2009-03-12 Thread Barbiturico76
Jiri Cincura ha scritto: On Wed, Mar 11, 2009 at 04:13, Barbiturico76 lucadomenos...@nospuminwind.it wrote: When I get data (text) from VarChar fields or Blob type 0 fields, I always receive the char '?' instead of '', '', '', '' or '' and I really cannot understand why. The data

Re: [Firebird-net-provider] Charset problems

2009-03-12 Thread Jiri Cincura
On Thu, Mar 12, 2009 at 16:34, Barbiturico76 lucadomenos...@nospuminwind.it wrote: So I need to convert the whole db to Unicode. How? Best way will be create new database and pump data from one to the other, i.e. fbexport could be helpful. -- Jiri {x2} Cincura (CTO x2develop.com)

Re: [Firebird-net-provider] Charset problems

2009-03-12 Thread Barbiturico76
Jiri Cincura ha scritto: On Thu, Mar 12, 2009 at 16:34, Barbiturico76 lucadomenos...@nospuminwind.it wrote: So I need to convert the whole db to Unicode. How? Best way will be create new database and pump data from one to the other, i.e. fbexport could be helpful.

Re: [Firebird-net-provider] Charset problems

2009-03-12 Thread Jiri Cincura
On Thu, Mar 12, 2009 at 17:20, Barbiturico76 lucadomenos...@nospuminwind.it wrote: But if there's no other way. You cna do it in place, of course. But you will face problems with dependencies etc. And if it's not 10GB database, this will be much easier. -- Jiri {x2} Cincura (CTO

Re: [Firebird-net-provider] Charset problems

2009-03-11 Thread Mercea Paul
] Sent: Wednesday, March 11, 2009 05:13 To: For users and developers of the Firebird .NET providers Subject: [Firebird-net-provider] Charset problems Dear Firebird gurus, I need your help! I'm a C# developer and I'm experencing some troubles when retrieving data from a Firebird 2.0 server

Re: [Firebird-net-provider] Charset problems

2009-03-11 Thread Luca
Mercea Paul ha scritto: Hi I think you could use 2 solution: 1. you could add charset to your connection string: FbConnectionStringBuilder fbcs = new FbConnectionStringBuilder(); fbcs.Database = @C:\Data\myDb.fdb; fbcs.Charset = NONE; - put your

Re: [Firebird-net-provider] Charset problems

2009-03-11 Thread Jiri Cincura
On Wed, Mar 11, 2009 at 04:13, Barbiturico76 lucadomenos...@nospuminwind.it wrote: When I get data (text) from VarChar fields or Blob type 0 fields, I always receive the char '?' instead of 'à', 'é', 'ì', 'ò' or 'ù' and I really cannot understand why. The data are correctly stored in the DB

Re: [Firebird-net-provider] Charset

2006-05-10 Thread Carlos Guzmán Álvarez
Hello: 1) with FbParameter it works 2) it works also with simple SQL-Query if table has an index on the field in where clause in other cases it doesn't seem to work for me Huummm i will see if i can do a test using Fb 1.5 -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/

Re: [Firebird-net-provider] Charset

2006-05-09 Thread paha
Got some information, maybe it can tell something 1) with FbParameter it works 2) it works also with simple SQL-Query if table has an index on the field in where clause in other cases it doesn't seem to work for me -- View this message in context:

Re: [Firebird-net-provider] Charset

2006-05-08 Thread paha
Looks as working fine for me using Firebird 2.0 RC 1 ... huummm ... I've tried it with older versions of FB Provider, but ...never mind, should be some stupid system issue can you do a test using parametrized queries ?? i can try, this problem isn't important on the current stage of my

Re: [Firebird-net-provider] Charset

2006-05-05 Thread Carlos Guzmán Álvarez
Hello: I have next function to execute SQL command Please can you send a test case to my private email ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain --- Using Tomcat but need to do more? Need to support web services, security?

[Firebird-net-provider] Charset

2006-05-03 Thread paha
Hi, i need help, i'm s stupid, i can't solve the problem: I have next function to execute SQL command public bool ExecSQL(string SQL) { bool result = true; try { if (m_fbConnection.State == System.Data.ConnectionState.Open)

Re: [Firebird-net-provider] Charset

2006-05-03 Thread paha
Sorry for previous POST, got it in HTML without BR Hi, need help, i'm s stupid, but i can't solve it: I have next function to execute SQL command public bool ExecSQL(string SQL) { bool result = true; try { if (m_fbConnection.State