I have loaded the same flat file into two different schemas of Vertica
but when I try to select records, It shows some special characters in one schema and no special characters in other schema.
Code: Select all
nnani=> select cntnt_id, cntnt_desc from db1.table1
nnani-> where cntnt_id IN (792,814);
cntnt_id | cntnt_desc
----------+-------------------------------------------------------------------------------------------------------------------------
--------------------------------------
792 | beat the purebred snail that Squidward has purchased; Mr. Krabs spen
ds time with SpongeBob and Patrick.
814 | when he refuses to share a toy; Mr. Krabs is nominated for the Cheapest Krab award
at an awards ceremony.
(2 rows)
nnani=> select cntnt_id, cntnt_desc from db2.table2
nnani-> where cntnt_id IN (792,814);
cntnt_id | cntnt_desc
----------+-------------------------------------------------------------------------------------------------------------------------
----------------------------------------
792 | beat the âpurebredâ
ds time with SpongeBob and Patrick.
814 | when he refuses to share a toy; Mr. Krabs is nominated for the âCheapest Krabâ
at an awards ceremony.
(2 rows)
I have higlighted the special characters.
How come they look different, are there any tweaks, we need to make