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

Resolve inconsistency between VARCHAR and STRING #146

Closed
ybyzek opened this issue Jan 14, 2022 · 4 comments
Closed

Resolve inconsistency between VARCHAR and STRING #146

ybyzek opened this issue Jan 14, 2022 · 4 comments

Comments

@ybyzek
Copy link
Contributor

ybyzek commented Jan 14, 2022

#131 (comment)

Looking for clarification on differentiation of VARCHAR vs STRING and when to use which. I usually see VARCHAR in the context below, but STRING also works:

CREATE STREAM pages (
   page STRING, ....

We have recipes that reference both...

@mjsax
Copy link
Member

mjsax commented Jan 21, 2022

ksqlDB uses STRING as synonym to VARCHAR -- so semantically there is no difference.

VARCHAR is the standard SQL type, even if it actually needs a "max size" parameter that ksqlDB does not implement. -- STRING is no standard SQL type (seems to be syntactic sugar -- but sure why ksqlDB added it). To technically neither VARCHAR nor STRING is standard SQL...

To avoid confusing users, it might be good to just pick either one and use it exclusively in all tutorials.

@ybyzek
Copy link
Contributor Author

ybyzek commented Jan 22, 2022

To avoid confusing users, it might be good to just pick either one and use it exclusively in all tutorials.

@mjsax agree. Which would be your recommendation, VARCHAR or STRING?

@ybyzek ybyzek changed the title Resolve inconsistency between VARCHAR and STRING Resolve inconsistency between VARCHAR and STRING Jan 22, 2022
@mjsax
Copy link
Member

mjsax commented Jan 24, 2022

I would go with VARCHAR.

@ybyzek
Copy link
Contributor Author

ybyzek commented Feb 2, 2022

Closing and moving to confluentinc/kafka-tutorials#1044

@ybyzek ybyzek closed this as completed Feb 2, 2022
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

2 participants