Bug #6667 rs.update error
| Submitted: | 16 Nov 2004 15:47 | Modified: | 3 Jul 2007 19:08 |
|---|---|---|---|
| Reporter: | Ender Li | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S2 (Serious) |
| Version: | 3.51.10 | OS: | Windows (Windows2000) |
| Assigned to: | Jim Winstead | CPU Architecture: | Any |
[16 Nov 2004 15:47]
Ender Li
[17 Nov 2004 17:36]
MySQL Verification Team
Could you please show for us the output of the below 2 commands using the mysql.exe client: show create table my_ado\G show variables like "%character%"; Thanks in advance.
[20 Nov 2004 13:17]
Ender Li
mysql> show create table my_ado\G
ERROR 1046 (3D000): No database selected
mysql> use test
Database changed
mysql> show create table my_ado\G
*************************** 1. row ***************************
Table: my_ado
Create Table: CREATE TABLE `my_ado` (
`id` int(11) NOT NULL default '0',
`name` varchar(20) default NULL,
`txt` text,
`dt` date default NULL,
`tm` time default NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=big5
1 row in set (0.01 sec)
mysql> show variables like "%character%";
+--------------------------+----------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----+
| character_set_client | latin1
|
| character_set_connection | latin1
|
| character_set_database | big5
|
| character_set_results | latin1
|
| character_set_server | big5
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 4.1\share\chars
ets/ |
+--------------------------+----------------------------------------------------
-----+
7 rows in set (0.00 sec)
[20 Jun 2007 19:00]
Jim Winstead
To use a different character set with Connector/ODBC, it is necessary to specify it as part of the DSN or connection string, which is a new feature in the upcoming 3.51.17.
[3 Jul 2007 19:08]
Paul DuBois
Noted in 3.51.17 changelog. It is now possible to specify a different character set as part of the DSN or connection string.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.