Oracle double byte space...

[WTFH]

Any Oracle SQL genius able to tell me how I can trim the trailing double byte spaces from fields?


rtrim(field) or rtrim(field, ' ') or rtrim(field, '<copy of double space character')
none of those work.

[MrMarkyMark]

TRIM function

Have you tried using trailing in conjunction with Trim?
Can't have a go fo you now, as I'm on the train

The invoice is in the post

[eek]

TRIM function

Have you tried using trailing in conjunction with Trim?
Can't have a go fo you now, as I'm on the train

The invoice is in the post

The default mode is Both so I don't Trailing helps.

More serious answer are you running this from a console or from a stored procedure.

If the former check the environment settings on your console (needs to be Japanese not English) if the latter something is definitely wrong....

[MrMarkyMark]

The default mode is Both so I don't Trailing helps.

More serious answer are you running this from a console or from a stored procedure.

If the former check the environment settings on your console (needs to be Japanese not English) if the latter something is definitely wrong....

Not if you are using rtrim it isn't

The other possible thing is he could have unknown characters in there, also.
I had this once and only realised they were there after I had looked at the data in a hexadecimal editor.

[eek]

Not if you are using rtrim it isn't

The other possible thing is he could have unknown characters in there, also.
I had this once and only realised they were there after I had looked at the data in a hexadecimal editor.

True but there are very strange interactions between consoles and servers if the environment settings differ between them.

The other approach is to wrap up your console sql script into a stored procedure, execute it and then delete the stored procedure.

[MrMarkyMark]

True but there are very strange interactions between consoles and servers if the environment settings differ between them.

The other approach is to wrap up your console sql script into a stored procedure, execute it and then delete the stored procedure.

Totally agree Bud.

Sorry, I should have added I thought your suggestion was a very good one.

[WTFH]

I'm running it on Oracle SQL Developer, and I am not a (database) genius.

[WTFH]

It looks like this:


ド　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 ||

ド　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　||

(I've added a || at the end to make it easier to see)

[eek]

That doesn't really help - you need the unicode/ hexadecimal view from say notepad++.

If you want a definitive its dodgy characters rather than console answer after that create stored procedures trim and select again....

Otherwise its environment interaction issues and I wish you luck for even oracle won't have a scooby's on how to fix it.

[darrylmg]

Are they definitely spaces?
If not, then you need to use either a substring or replace function.
I think from memory: REPLACE or SUBSTR.