php - Cache ODBC characters -
ok our database intersystems cache, i'm trying values 1 table via php. managed values values incomplete , have symbols @ end.
this characters.. php99¥7“\ߦ
then tried values via crystal reports.. no symbols still long values incomplete, viewed field type , says string[30], thought it's limited 30 characters. when viewed in vb application shows more 30 characters.
example:
php = "the quick brown fox jumps overphp99¥7“\ߦ" crystal reports = "the quick brown fox jumps over" vb application = "the quick brown fox jumps on lazy dog"
i don't have source of vb can't see sql running.
anyone can meh...?
when working directly globals in caché constraints of length of columns of table not verified. way possible put info longer max length of column row.
on other hand odbc , crystal reports (i think use odbc in background) base column length on definition of table.
the easy solution in case rising length of column in question. make crystal reports , php both return correct value. question if solves problem. perhaps want max length of column 30 characters. in case hard check needs built vb application directly accessing globals.
Comments
Post a Comment