odbc connection test: <<warning: would handle the encoding 'utf-8' like ascii>>

[m.ardito]

Hi all,

Hi, i'm moving first steps around jboss as and teiid.

I just solved (thanks ramesh) my first mistake in configuring the quickstart portfolio-ds.xml, and now the virtual databas is UP

now, as could be my main use for teiid, created a system dsn (win7prox64) from the ODBC administration console

(used postgresql odbc unicode driver)

(C:\Windows\SysWOW64\odbcad32.exe): thought i got no errors like before, now i got this:

<<warning: would handle the encoding 'utf-8' like ascii>>

i'm using teiid 7.2 on jboss as 5.1 on a ubuntu 10.04 server distribution, using the quickstart examples (a simple derby database and a CSV file)

postgres odbc connector is 08.04.0200 and i double checked all base and "datasource" parameters to be like in odbc section like:

http://docs.jboss.org/teiid/7.2.0.Final/client-developers-guide/en-US/html/ODBC.html#install

even googled a while, and searched this forum, with no success: so, what could this warning mean and, should i care?

edit: i now tried the other driver, postgres ANSI, and this brings no warning, and the connection is successful...

i still wonder if i should care about the other driver, and how, or just keep on with the ANSI one...

Thxs, Marco

[rareddy]

It means that driver not going to handle any unicode character set with that configuration. I am not sure how to fix the error yet. Are you using 64 bit driver of your PostgreSQL ODBC? Looks like you are using x64 Windows box.

Ramesh..

[m.ardito]

Yes, as i said is a win7 professional x64. it works with ansi, though. i can live with that, if it is fine... just posted about the strange warning.

As you can see in the next thread, i am really newbie in teiid, and need to re-read all the docs carefully maybe...

Thanks, anyway