Skip to Content.
Sympa Menu

freetds - [freetds] charset problem with Sybase on SunOS server and Ubuntu client

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frederick.Dubberspear AT sogetthis.com
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] charset problem with Sybase on SunOS server and Ubuntu client
  • Date: Wed, 19 Nov 2008 22:41:18 -0500

> I think this was fixed long ago. If you have a problem with 0.82, I'll
look into it.

Thanks very much for the information. We've since upgraded and still seeing
the
same error. The log file is attached. Please, let me know if there's any more
information about the client/server you need.

TIA
log.c:190:Starting log file for FreeTDS 0.82
on 2008-11-19 22:26:47 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "UTF-8" character set
iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
net.c:210:Connecting to $IP_ADDRES port $PORT (TDS version 5.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
net.c:779:Sending packet
0000 02 00 02 00 00 00 00 00-6c 61 6d 70 2e 72 69 63 |........ $HOST...|
0010 68 6c 61 6e 64 2e 6c 69-62 2e 73 63 2e 75 73 00 |$CLIENT_DOMAIN...|
0020 00 00 00 00 00 00 17 73-61 00 00 00 00 00 00 00 |.......$UN.......|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 02 68 74-6f 32 32 37 00 00 00 00 |......$PASSWD....|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 06 33 37 38-37 36 00 00 00 00 00 00 |.....378 76......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 00 00 |........ ........|
0090 00 00 00 00 50 48 50 20-35 00 00 00 00 00 00 00 |....PHP 5.......|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 05 68 70 5f 68 6f-72 69 7a 6f 6e 00 00 00 |...$SERVERNAME...|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 0a 00 06 68 74 6f 32-32 37 00 00 00 00 00 00 |....$PASSWD......|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01d0 00 08 05 00 00 00 44 42-2d 4c 69 62 72 61 72 79 |......DB -Library|
01e0 0a 05 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|

net.c:779:Sending packet
0000 02 01 00 61 00 00 00 00-00 00 00 00 00 00 0a 00 |...a.... ........|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 55 54 46 |........ .....UTF|
0020 2d 38 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |-8...... ........|
0030 00 00 00 00 00 00 00 00-00 00 00 05 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00-e2 16 00 01 09 00 08 0e |........ ........|
0050 6d 7f ff ff ff fe 02 09-00 00 00 00 02 68 00 00 |m....... .....h..|
0060 00 - |.|

token.c:312:tds_process_login_tokens()
net.c:592:Received header
0000 04 01 01 42 00 00 00 00- |...B....|

net.c:671:Received packet
0000 e5 64 00 69 09 00 00 02-0b 05 5a 5a 5a 5a 5a 00 |.d.i.... ..ZZZZZ.|
0010 01 00 49 00 43 61 6e 6e-6f 74 20 66 69 6e 64 20 |..I.Cann ot find |
0020 74 68 65 20 72 65 71 75-65 73 74 65 64 20 63 68 |the requ ested ch|
0030 61 72 61 63 74 65 72 20-73 65 74 20 69 6e 20 53 |aracter set in S|
0040 79 73 63 68 61 72 73 65-74 73 3a 20 20 6e 61 6d |yscharse ts: nam|
0050 65 20 3d 20 27 55 54 46-2d 38 27 2e 0a 06 53 59 |e = 'UTF -8'...SY|
0060 42 41 53 45 00 00 00 e5-38 00 6b 09 00 00 01 0a |BASE.... 8.k.....|
0070 05 5a 5a 5a 5a 5a 00 01-00 1d 00 4e 6f 20 63 6f |.ZZZZZ.. ...No co|
0080 6e 76 65 72 73 69 6f 6e-73 20 77 69 6c 6c 20 62 |nversion s will b|
0090 65 20 64 6f 6e 65 2e 0a-06 53 59 42 41 53 45 00 |e done.. .SYBASE.|
00a0 00 00 e3 0f 00 01 06 6d-61 73 74 65 72 06 6d 61 |.......m aster.ma|
00b0 73 74 65 72 e5 41 00 45-16 00 00 02 0a 05 5a 5a |ster.A.E ......ZZ|
00c0 5a 5a 5a 00 01 00 26 00-43 68 61 6e 67 65 64 20 |ZZZ...&. Changed |
00d0 64 61 74 61 62 61 73 65-20 63 6f 6e 74 65 78 74 |database context|
00e0 20 74 6f 20 27 6d 61 73-74 65 72 27 2e 0a 06 53 | to 'mas ter'...S|
00f0 59 42 41 53 45 00 00 00-e3 06 00 04 03 35 31 32 |YBASE... .....512|
0100 00 ad 14 00 05 05 00 00-00 0a 73 71 6c 20 73 65 |........ ..sql se|
0110 72 76 65 72 0c 05 00 00-e2 16 00 01 09 00 08 02 |rver.... ........|
0120 61 41 ff ff ff e6 02 09-00 00 00 00 02 00 00 00 |aA...... ........|
0130 00 fd 02 00 02 00 ee 00-00 00 |........ ..|

token.c:316:looking for login token, got e5(EED)
token.c:108:tds_process_default_tokens() marker is e5(EED)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0x95eeae8, 0x9642848, 0xbfbf6e0c)
dbutil.c:87:msgno 2409: "Cannot find the requested character set in
Syscharsets: name = 'UTF-8'.
"
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got e5(EED)
token.c:108:tds_process_default_tokens() marker is e5(EED)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0x95eeae8, 0x9642848, 0xbfbf6e0c)
dbutil.c:87:msgno 2411: "No conversions will be done.
"
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0x9642848, 1, master, master)
token.c:316:looking for login token, got e5(EED)
token.c:108:tds_process_default_tokens() marker is e5(EED)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
dbutil.c:86:_dblib_handle_info_message(0x95eeae8, 0x9642848, 0xbfbf6e0c)
dbutil.c:87:msgno 5701: "Changed database context to 'master'.
"
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
dblib.c:325:db_env_chg(0x9642848, 4, , 512)
token.c:316:looking for login token, got ad(LOGINACK)
token.c:316:looking for login token, got e2(CAPABILITY)
token.c:108:tds_process_default_tokens() marker is e2(CAPABILITY)
token.c:316:looking for login token, got fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
token.c:2232: rows_affected = 238
token.c:393:leaving tds_process_login_tokens() returning 1
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 0f 01 00 21 00 00 00 00-21 14 00 00 00 00 73 65 |...!.... !.....se|
0010 74 20 74 65 78 74 73 69-7a 65 20 36 34 35 31 32 |t textsi ze 64512|
0020 20 - | |

token.c:495:tds_process_tokens(0x9642848, 0xbfbf6f28, 0xbfbf6f24, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 00 00 00 00- |........|

net.c:671:Received packet
0000 fd 00 00 02 00 00 00 00-00 |........ .|

token.c:510:processing result tokens. marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x9642848, 0xbfbf6f28, 0xbfbf6f24, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
dblib.c:237:dblib_add_connection(0xb73af340, 0x9642848)
dblib.c:4208:dbsetopt(0x9642148, 14, 2, -1)
dblib.c:1372:dbclose(0x9642148)
dblib.c:256:dblib_del_connection(0xb73af340, 0x9642848)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
dblib.c:303:dblib_release_tds_ctx(1)
dblib.c:5727:dbfreebuf(0x9642148)
dblib.c:718:dbloginfree(0x9642098)
dblib.c:1442:dbexit(void)
dblib.c:1442:dbexit(void)
dblib.c:303:dblib_release_tds_ctx(1)



Archive powered by MHonArc 2.6.24.

Top of Page