sqlgoogle-openid

What is the maximum length of the profile picture url inside the openid jwt "picture" claim, returned by accounts.google.com

I am trying to save the profile picture URL inside an SQL database, and having trouble determining, how big should the VARCHAR(X) column should be. For now, I've just picked a random "should be big enough number" for X but I would like my database to be more optimal.

Solution

  • Google does not say:

    https://developers.google.com/people/api/rest/v1/people#Person.Photo

    I notice that internal-company-visibility urls are much longer than public-visibility urls. (eg 1027-1030 chars vs 90-93 chars)