Hello.
See:
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
"Cecep Rosuludin" <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> I found an error in mysql message, when I tried to excute this sql in mysql=
> front:
>
> select dsr2.mother_vessel,mother_vessel_voy,voyage.v
Hello,
I think your tables have a collation different from the connection collation.
Open mysql client:
mysql> show variables like 'colla%';
+--+---+
| Variable_name| Value |
+--+---+
| collation_connection
Dear All,
I found an error in mysql message, when I tried to excute this sql in
mysqlfront:
select dsr2.mother_vessel,mother_vessel_voy,voyage.voy_aims,voyage.td,
poo.loading_port_name,pod.disch_name from dsr2
left join voyage on voyage.voy=dsr2.mother_vessel_voy
left join poo on poo.loading_por