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

oracle data types VARCHAR vs VARCHAR2 #189

Closed
washcycle opened this issue Jun 9, 2018 · 1 comment
Closed

oracle data types VARCHAR vs VARCHAR2 #189

washcycle opened this issue Jun 9, 2018 · 1 comment
Labels
feature a feature request or enhancement oracle

Comments

@washcycle
Copy link

washcycle commented Jun 9, 2018

I am suggesting that we change VARCHAR to VARCHAR2, I'd be willing to create the pull request, but I want to know what you think, or if there is a reason to use VARCHAR over the recommended VARCHAR2?

"VARCHAR datatype is synonymous with the VARCHAR2 datatype. To avoid possible changes in behavior, always use the VARCHAR2 datatype to store variable-length character strings."

https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT1822

@jimhester
Copy link
Contributor

No, no reason, I just didn't know about this distinction.

Please create a PR to make the change!

https://stackoverflow.com/a/1171200/2055486 has some more details on the reasoning (for my future reference).

@jimhester jimhester added the feature a feature request or enhancement label Jun 10, 2018
@krlmlr krlmlr added the oracle label Jan 8, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature a feature request or enhancement oracle
Projects
None yet
Development

No branches or pull requests

3 participants