I have the table
CREATE TABLE `patient` (
`idPatient` int(10) unsigned NOT NULL auto_increment,
`LName` varchar(45) default NULL,
`FName` varchar(45) default NULL,
`PName` varchar(45) default NULL,
`Street` varchar(45) default NULL,
`House` int(10) unsigned default NULL,
`Building` varchar(3) default NULL,
`Apartament` varchar(10) default NULL,
PRIMARY KEY (`idPatient`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
My TZConnection has codepage=cp1251
when I execute a query
'select a.*,concat_ws(' ',a.lname,a.fname,a.pname) as fio,a.street,
concat_ws(',',a.street,
concat_ws('/', a.house,a.building),
a.apartament
) as address
from patient as a
order by a.lname,a.fname,a.pname'
the field 'address' don't displays in codepage=cp1251
but the field 'fio' is right.
But if I execute the query
select a.*,concat_ws(' ',a.lname,a.fname,a.pname) as fio,a.street,
concat_ws(',',a.street,
concat_ws('/',cast(a.house as char),a.building),
a.apartament
) as address
from patient as a
order by a.lname,a.fname,a.pname'
then all it's ok
Why?Is it bug or propery of Mysql?
Wrong codepage
Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs
Moderators: gto, cipto_kh, EgonHugeist
-
- Fresh Boarder
- Posts: 2
- Joined: 21.03.2006, 06:41
Return to “6.5.1 (alpha) - 6.6.x (beta)”
Jump to
- Links
- ↳ Bugtracker
- ↳ Downloads
- ↳ Subversion
- ↳ GitHub
- ZEOS Library - General
- ↳ Announcements
- ↳ Downloads
- ↳ Documentations
- ↳ Tutorials
- ↳ ZDBC (ZEOS Database Connectivity)
- ↳ User Contributions
- ↳ Feature Requests
- ↳ User Patches
- ZEOS DBO v8.x
- ↳ ZeosLib 7.3/8.0 Forum
- ZEOS DBO v7.x
- ↳ ZeosLib 7.2 Forum
- ↳ ZeosLib 7.1 stable Forum
- ↳ ZeosLib 7.0 Stable Forum
- ↳ ZeosLib 7.0 Beta Forum
- SQL Servers and Databases
- ↳ ADO
- ↳ DB2
- ↳ Firebird
- ↳ Interbase
- ↳ MS SQL Server
- ↳ MySQL
- ↳ Oracle
- ↳ OleDB (Microsoft Windows)
- ↳ ODBC
- ↳ PostgreSQL
- ↳ SQLite
- ↳ Sybase ASE
- Compiler related
- ↳ CBuilder / C++
- ↳ Lazarus / Freepascal
- ZEOS DBO V 6.x
- ↳ 6.6 - stable
- ↳ 6.5.1 (alpha) - 6.6.x (beta)
- ↳ 6.1.5
- ↳ Other 6.x Versions
- ↳ Bug Reports
- ZEOS DBO V 5.x
- ↳ 5.x Versions
- Software projects using ZeosLib
- ↳ SQLite Administrator
- Other and Non-Technical
- ↳ Off Topic