I have a simple table in MySQL with a first_name varbinary(255) column.
it is varbinary because I will end up doing AES_Encrypt on it.
For now, the data is not encrypted.
I inserted "rpurdy" into the first_name column.
if i use, cast("first_name" as char(100) ) in mysql i can see my data fine.
if i use this in Oracle pl/sql I get what i see below.
please help. thank you.
SELECT cast("first_name" as char(100) ) as Test1
FROM "test1_user"@dblink1
TEST1