They are definitely spaces, thanks for the help everyone, I've got the ClientCo to assign a permie in the US to the issue, meanwhile the IT manager out here is going to try to extract the data from their AS/400 without the spaces and send it to me again to upload.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Oracle double byte space...
Collapse
X
-
-
Comment
-
-
Originally posted by stek View PostIBM i now....
Like calling your laptop now "an IBM PC compatible".Comment
-
Originally posted by WTFH View PostThey are definitely spaces, thanks for the help everyone, I've got the ClientCo to assign a permie in the US to the issue, meanwhile the IT manager out here is going to try to extract the data from their AS/400 without the spaces and send it to me again to upload.The Chunt of Chunts.Comment
-
Comment
-
Originally posted by MrMarkyMark View PostNotepad ++ may tell a different story as eek has suggestedmerely at clientco for the entertainmentComment
-
Originally posted by WTFH View PostIt looks like this:
ド ||
Code:ド ||
(I've added a || at the end to make it easier to see)
Code:WITH xyz AS ( SELECT 'ド ' txt FROM DUAL UNION SELECT '1 ' from dual UNION SELECT '2 ' txt FROM DUAL ) SELECT txt , LENGTH(txt) , RTRIM(txt) , LENGTH(RTRIM(txt)) , TRIM(txt) , LENGTH(TRIM(txt)) , ASCIISTR(txt) FROM xyz;
Code:\30C9\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000
Code:RTRIM(REPLACE(txt,UNISTR('\3000'),' '))
Last edited by RonBW; 1 December 2016, 13:09.First they ignore you, then they laugh at you, then they fight you, then you win. But Gandhi never had to deal with HMRCComment
-
Ah, now that makes sense - Unicode character 3000 is an ideographic space. Tomorrow I will have a play in SQL.
Thanks!…Maybe we ain’t that young anymoreComment
-
Originally posted by WTFH View PostThey are definitely spaces, thanks for the help everyone, I've got the ClientCo to assign a permie in the US to the issue, meanwhile the IT manager out here is going to try to extract the data from their AS/400 without the spaces and send it to me again to upload.Originally posted by MrMarkyMark View PostThe 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.
Originally posted by RonBW View PostI copied your string into SQL Developer and those aren't spacesThe Chunt of Chunts.Comment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment