MySQL Forums
Forum List  »  Newbie

Error de odbc al realizaruna consulta
Posted by: Julio Ortega
Date: June 01, 2021 01:57PM

se me presenta el siguiente mensaje al realizar una consulta utilizando odbc
MENSAJE DE ERROR
MySQL:501[MySQL][ODBC 8.0(w) Driver][mysqld-5.5.5-10.1.38-MariaDB]String data, right truncated

CONSULTA
SELECT concat(cli_nombreE, ' ',cli_nombre1 , ' ' , cli_nombre2, ' ' , cli_aPaterno,' ', cli_aMaterno ) FROM CatClientes ORDER BY cli_aPaterno

SI MODIFICO EL QUERY
SELECT concat(cli_nombreE, ' ',cli_nombre1 , ' ' , cli_nombre2, ' ' , cli_aPaterno,) FROM CatClientes ORDER BY cli_aPaterno
SIN PROBLEMA
O MODIFICO
SELECT concat(cli_nombre1 , ' ' , cli_nombre2, ' ' , cli_aPaterno,' ', cli_aMaterno ) FROM CatClientes ORDER BY cli_aPaterno
SINPROBLEMA

Options: ReplyQuote


Subject
Written By
Posted
Error de odbc al realizaruna consulta
June 01, 2021 01:57PM


Sorry, you can't reply to this topic. It has been closed.

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.