In a table with a column of data type (long) binary, when altering that column to data type (long) varchar/nvarchar, will that somehow convert existing data?
And what happens when doing the opposite, i.e. altering a column of data type (long) varchar/nvarchar to (long) binary?
The v12.0.1. docs tell
I'm not sure what defines the necessity here. Is something like csconvert() called here with the according charsets?
(I have stored binary data and would convert the column to nvarchar as the original data is in utf-8, so I hope they will remain as-is.)
Just to clarify: I'm not dealing with varchar/nvarchar conversion...
You will need to verify this is valid in your situation and that you have valid character data actually stored in your blob columns. but ...
There should be no conversion when you attempt to do this. If you had a requirement to do so you would need to do your own CSCONVERT-style conversions yourself, since only you can know something about the encoding of the raw data stored there. But it sounds like you may not have to worry about that.
Binary object are effectively the "Any" data type and have no meaning or context information associated with them.
answered 21 Mar '16, 17:14
Nick Elson S...