Default size Varchar field

Discuss the database features
Post Reply
FKlusmann
Posts: 43
Joined: Fri Jan 20, 2017 3:22 am

Default size Varchar field

Post by FKlusmann »

Villeroy wrote:By default this setting is 1930. This is the setting which determines if 1/1/30 is meant to be in 2030 or 1930. It does not impose any limit to the entered date.
You always set me straight. Thank you and Happy New Year!

An off-topic question: LO 7.0.3.1, when creating a table in Design View, defaults the length of Text[VARCHAR] to 100. Is there a way to change this to 35? Thanks again for all your help.
 Edit: Split from Date field changing as this is a different question.
Please start a new topic for a new question.
 
Thank you ALL! (Win 10 - LibreOffice Version: 7.0.3.1 (x64))
Saving the Planet! Only recycled electrons were used in this post!
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Default size Varchar field

Post by Villeroy »

I don't know. I write my tables in SQL because it is easier.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply