Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support Oracles multibyte datatype statements #656

Closed
vvursT opened this issue Dec 3, 2013 · 1 comment
Closed

Support Oracles multibyte datatype statements #656

vvursT opened this issue Dec 3, 2013 · 1 comment

Comments

@vvursT
Copy link

vvursT commented Dec 3, 2013

Oracle supports special multibyte datatypes to be able to save unicode characters within a "not unicode charset database instance" (see http://www.orafaq.com/wiki/NVARCHAR2 for example)

Statements with that N' notation aren't parsed properly by the SqlStatementBuilder and are interpreted as multiline statement thus the migration will fail. The given test example will also fail:

assertFalse(new OracleSqlStatementBuilder()
.endsWithOpenMultilineStringLiteral("INSERT INTO nvarchar2_test VALUES ( N'qwerty' )"));

@vvursT
Copy link
Author

vvursT commented Dec 4, 2013

Thanks to https://github.com/shadev who discovered this issue!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant