Odbc Import Not Support Chinese In 4.1beta 8

[jhstone_china]

administrator:

i use 4.1betea 8 import data from oracle,but the result does not display correct,it is not support chinese, in 4.06 it is right, sorry for my english.please see attached file

[Ritesh]

Do you mean v4.06 ODBC Import Tool?

[Ritesh]

Can you email me sample data so that we can reproduce the problem?

What do you get when you execute the following query?

Code:

show variables like '%char%'

[jhstone_china]

Ritesh wrote on Aug 8 2005, 06:36 AM:

Can you email me sample data so that we can reproduce the problem?

What do you get when you execute the following query?

Code:

show variables like '%char%'

[post=”6797″]<{POST_SNAPBACK}>[/post]

[jhstone_china]

Ritesh wrote on Aug 8 2005, 06:10 AM:

Do you mean v4.06 ODBC Import Tool?

[post=”6796″]<{POST_SNAPBACK}>[/post]

yes

[Ritesh]

Can you send me sample data to reproduce the problem?

What do you get when you execute the following query?

Code:

show variables like '%char%'

[jhstone_china]

Ritesh wrote on Aug 8 2005, 08:23 AM:

Can you send me sample data to reproduce the problem?

What do you get when you execute the following query?

Code:

show variables like '%char%'

[post=”6801″]<{POST_SNAPBACK}>[/post]

what is mean “sample data”? how can i get sample data? could you explain it ?

sorry for my english.

thank you!

[Ritesh]

By “sample data”, I meant two things:

– CREATE TABLE statement of the table.

– A few INSERT INTO statements for the data.

You can get this by exporting the table structure and data as SQL scripts.

BTW, have you tried importing data using v4.1 BETA 9. I had sent you a PM regarding the same.

You can download it from the same link as BETA 8:

http://www.webyog.com/forums/index.php?sho…st=0&#entry6743

[jhstone_china]

to Ritesh:

😆 😆 thank you,my problem was solved in version 4.1 B9.

but i report another problem:

my oracle client version is 9.2.0.1 when i using odbc import tool at 'specify table copy or query' step, click 'next',sqlyog become slowly and show a dialog box(see attachement),and all source tables are selected,i must deselect all fisrst,then select i want. in another computer oracle client version is 8.1.7,that have no problem above. the problem also in version B8

[Ritesh]

By Oracle client, do you mean – ODBC client version or Oracle server version?

[jhstone_china]

Ritesh wrote on Aug 9 2005, 05:58 AM:

By Oracle client, do you mean – ODBC client version or Oracle server version?

[post=”6811″]<{POST_SNAPBACK}>[/post]

i mean odbc client version ,not server version

[Ritesh]

What is your Oracle server version?

[jhstone_china]

Ritesh wrote on Aug 9 2005, 06:13 AM:

What is your Oracle server version?

[post=”6815″]<{POST_SNAPBACK}>[/post]

server is 8.1.6

[Ritesh]

This is very strange.

ODBC 9 driver returns temporary system tables when we query it to give table info. In the case of ODBC 8 driver – it does not 😮

By default, we try to select all the tables that are returned by the driver and get their column info. When we ask for column information for the extra tables – ODBC driver throws up an error saying that there no column for the mentioned table and thus the warning in SQLyog.

I believe its an issue with ODBC driver for Oracle rather then SQLyog. Anyway, SQLyog v4.1 BETA 10 will have a workaround for this situation.

[Ritesh]

We have released v4.1 BETA 10 that fixes the above issue. For more info, please visit http://www.webyog.com/forums/index.php?act…&st=0#entry6827

[Ritesh]

Can you confirm that BETA 10 fixes the above problem?

[jhstone_china]

Ritesh wrote on Aug 10 2005, 04:36 AM:

Can you confirm that BETA 10 fixes the above problem?

[post=”6829″]<{POST_SNAPBACK}>[/post]

yes,fixed.thank you!! 😛 😛

[Author]

Posts