You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
And then, I execute the following sql script:
select cast('ⅣEA期' as binary) from dual;
It returns �EA�
I don't understand that why It missed an â when I execute the first sql script and that's not the right value I really want.
Help me please!
Thanks a lot.
The text was updated successfully, but these errors were encountered:
gitpypy
changed the title
Different binary result returned by cast function and preg_capture function
Different binary result returned by mysql function cast and preg_capture
Jun 2, 2017
Hi!
I met a problem when I was using preg_capture function to get some value.
First, I execute the following sql script:
select preg_capture('/([ⅠVIⅡⅢⅣ].{0,3}期)/', 'ⅣEA期' );
It returns the blob value �£EAæ��
And then, I execute the following sql script:
select cast('ⅣEA期' as binary) from dual;
It returns �EA�
I don't understand that why It missed an â when I execute the first sql script and that's not the right value I really want.
Help me please!
Thanks a lot.
The text was updated successfully, but these errors were encountered: