Default size Varchar field

Discuss the database features

Default size Varchar field

Postby FKlusmann » Sat Jan 02, 2021 5:17 am

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, 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: (x64))
Saving the Planet! Only recycled electrons were used in this post!
Posts: 43
Joined: Fri Jan 20, 2017 3:22 am

Re: Default size Varchar field

Postby Villeroy » Mon Jan 04, 2021 8:04 pm

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
User avatar
Posts: 29896
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests